package cn.ac.siom.query.service;

import cn.ac.siom.query.vo.Tab_Thesis;
import cn.ac.siom.query.vo.resultType_jl;

import java.sql.SQLException;
import java.util.List;

public interface ITab_ThesisService {

     List<Tab_Thesis> list_Books() throws SQLException;
     List<Tab_Thesis> list_Report() throws SQLException;
    List<Tab_Thesis> findBookSection() throws SQLException;
     List<Tab_Thesis> list_Journal() throws SQLException;
     List<Tab_Thesis> list_Conference() throws SQLException;
    List<Tab_Thesis> list_NO(Integer i_id) throws SQLException;
     List<Tab_Thesis> list_Search(Integer rownum, Integer page_id,String keywords) throws SQLException;
     Integer search_count(String keywords)throws SQLException;
     List<Tab_Thesis> list_page(Integer rownum, Integer page_id,String keywords) throws SQLException;
     Integer list_count(String keywords)throws SQLException;
    Tab_Thesis list_reference(Integer i_id) throws SQLException;
    List<Tab_Thesis> list_tj(Integer i_id) throws SQLException;
    List<Tab_Thesis> list_page_tj(Integer rownum, Integer page_id) throws SQLException;
    Integer list_count_tj()throws SQLException;
    List<Tab_Thesis> list_ByBooksID(String id) throws SQLException;
    List<Tab_Thesis> list_Search_jl( Integer page_id,String keywords,Integer type,String mold) throws SQLException;
    List<resultType_jl> search_count_jl(String keywords, String mold)throws SQLException;
    Integer CountPage_jl(String keywords, String value,Integer type)throws SQLException;
    List<Tab_Thesis> list_kj(Integer i_id) throws SQLException;
    List<Tab_Thesis> list_page_kj(Integer rownum, Integer page_id) throws SQLException;
    Integer list_count_kj()throws SQLException;
    List<Tab_Thesis> list_kj_home()throws SQLException;
    Integer count1() throws SQLException;
    List<Tab_Thesis> search1(Integer pageid, String mold, Integer type) throws SQLException;
    List<resultType_jl> stat1(String mold) throws SQLException;
    Integer count2() throws SQLException;
    List<Tab_Thesis> search2(Integer pageid, String mold, Integer type) throws SQLException;
    List<resultType_jl> stat2(String mold) throws SQLException;
    Integer count3() throws SQLException;
    List<Tab_Thesis> search3(Integer pageid, String mold, Integer type) throws SQLException;
    List<resultType_jl> stat3(String mold) throws SQLException;
    Integer count4() throws SQLException;
    List<Tab_Thesis> search4(Integer pageid, String mold, Integer type) throws SQLException;
    List<resultType_jl> stat4(String mold) throws SQLException;
    Integer count5() throws SQLException;
    List<Tab_Thesis> search5(Integer pageid, String mold, Integer type) throws SQLException;
    List<resultType_jl> stat5(String mold) throws SQLException;
    List<Tab_Thesis> combSearch(Integer page_id, String title, String author, String publisher, String metting, String op1, String op2, String op3) throws SQLException;
    Integer combSearchCount(Integer page_id, String title, String author, String publisher, String metting, String op1, String op2, String op3) throws SQLException;
    List<resultType_jl> combSearchStat(String title, String author, String publisher, String metting, String op1, String op2, String op3, String mold)throws SQLException;
}
